Model Table REPORT CODE

This cube dimension represents report cost code in Project Reporting and is based on the IFS Applications dimension DIM_REPORT_CODE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

AttributeDescription (where applicable)
Report CodeReport Code
Report Code GroupReport Code Group
Report Code IDReport Code ID
Report Code NameReport Code Name
Report Code TypeReport Code Type
Valid FromValid From
Valid ToValid To
COMPANYCompany
CODEReport Code

Hierarchies

HierarchyLevel

USED BY MODEL(S)

Model Name

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model TableDW Source view (SQL Server)BI Access ViewReferenced Information SourceRecommended Access Type
REPORT CODEDIM_REPORT_CODE_TMDIM_REPORT_CODE_BIDIM_REPORT_CODEOn Line